package com.sharemarking.wa.platform.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.sharemarking.wa.common.entity.OrderAddress;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @author dxy
 */
@Repository
public interface OrderAddressMapper extends BaseMapper<OrderAddress> {
    @Select("SELECT concat(province,city,area,address) AS address FROM wa_order_address WHERE order_id = #{orderId} AND type = #{type} LIMIT 1")
    String getAddressByOrderId(@Param("orderId") Integer orderId,@Param("type") Integer type);
}
